database connectivity asp.net using ms sql server (update record)

 database connectivity asp.net using ms sql server (update record)

A) Create Database and table (Click here)

B) Create New Project and Design Form

C) Add App_Code Folder and Class File  (Click here)

D) Add Connection  (Click here)

E) Code for Update Records Button:

protected void Button2_Click(object sender, EventArgs e)

    {

        DatabaseConnectivityClass obj = new DatabaseConnectivityClass();

        DataSet ds = new DataSet();

        ds = obj.DataSetReturn("update StudentTable set NameofStudent='"+TextBox1.Text +"', CourseName='"+TextBox2.Text+"', Address='"+TextBox3.Text+"',ContactNumber='"+TextBox4.Text+"' where StudentId="+TextBox5.Text);

        Label1.Text = "Data has been Updated";

 }

F) Code for Search Button:

protected void Button1_Click(object sender, EventArgs e)

    {

     

        DatabaseConnectivityClass obj = new DatabaseConnectivityClass();

        DataSet ds = new DataSet();

        ds = obj.DataSetReturn("Select *from StudentTable where StudentId=" + TextBox5.Text);

 

        if (ds.Tables[0].Rows.Count >= 1)

        {

            Label1.Text = "Record Found";

            TextBox1.Text = ds.Tables[0].Rows[0]["NameofStudent"].ToString();

            TextBox2.Text = ds.Tables[0].Rows[0]["CourseName"].ToString();

            TextBox3.Text = ds.Tables[0].Rows[0]["Address"].ToString();

            TextBox4.Text = ds.Tables[0].Rows[0]["ContactNumber"].ToString();

            Button2.Enabled = true;

        }

        else

        {

            Label1.Text = "Record Not Found";

            TextBox1.Text = "";

            TextBox2.Text = "";

            TextBox3.Text = "";

            TextBox4.Text = "";

            Button2.Enabled = false;

 

        }

    }

G) Class Code:-

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Data.SqlClient; // Add Namespace

using System.Configuration;

using System.Data; // Add Namespace

 

/// <summary>

/// Summary description for DatabaseConnectivityClass

/// </summary>

public class DatabaseConnectivityClass

{

   

    SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MSQL"].ToString());

 

    public int ForQuery(String sqlcmd)

    {

        con.Open();

        SqlCommand cmd = new SqlCommand(sqlcmd, con);

        int x = cmd.ExecuteNonQuery();

        con.Close();

        return x;

   }

     public DataSet DataSetReturn(String strcmd)

    {

        con.Open();

        // OleDbDataAdapter da = new OleDbDataAdapter(strcmd, con);

        SqlDataAdapter da = new SqlDataAdapter(strcmd, con);

        DataSet ds = new DataSet();

        da.Fill(ds);

        con.Close();

        return ds;

    }

 }